package com.ruoyi.predict.mapper;

import java.util.List;
import com.ruoyi.predict.domain.BoleScriptPredictionRecord;
import org.apache.ibatis.annotations.Select;

/**
 * 岗位预测记录Mapper接口
 * 
 * @author wwujiale
 * @date 2025-08-03
 */
public interface BoleScriptPredictionRecordMapper 
{
    //根据userId查询
    @Select("select " +
            "id as id, " +
            "prediction_no as predictionNo, " +
            "train_id as trainId, " +
            "prediction_job as predictionJob, " +
            "prediction_job_code as predictionJobCode, " +
            "prediction_info as predictionInfo, " +
            "prediction_result as predictionResult, " +
            "user_id as userId, " +
            "prediction_time as predictionTime, " +
            "create_time as createTime, " + "update_time as updateTime, " +
            "remark as remark " +
            "from bole_script_prediction_record " +
            "where user_id = #{userId}")
    public BoleScriptPredictionRecord selectBoleScriptPredictionRecordByUserId(Long userId);
    /**
     * 查询岗位预测记录
     * 
     * @param id 岗位预测记录主键
     * @return 岗位预测记录
     */
    public BoleScriptPredictionRecord selectBoleScriptPredictionRecordById(Long id);

    /**
     * 查询岗位预测记录列表
     * 
     * @param boleScriptPredictionRecord 岗位预测记录
     * @return 岗位预测记录集合
     */
    public List<BoleScriptPredictionRecord> selectBoleScriptPredictionRecordList(BoleScriptPredictionRecord boleScriptPredictionRecord);

    /**
     * 新增岗位预测记录
     * 
     * @param boleScriptPredictionRecord 岗位预测记录
     * @return 结果
     */
    public int insertBoleScriptPredictionRecord(BoleScriptPredictionRecord boleScriptPredictionRecord);

    /**
     * 修改岗位预测记录
     * 
     * @param boleScriptPredictionRecord 岗位预测记录
     * @return 结果
     */
    public int updateBoleScriptPredictionRecord(BoleScriptPredictionRecord boleScriptPredictionRecord);

    /**
     * 删除岗位预测记录
     * 
     * @param id 岗位预测记录主键
     * @return 结果
     */
    public int deleteBoleScriptPredictionRecordById(Long id);

    /**
     * 批量删除岗位预测记录
     * 
     * @param ids 需要删除的数据主键集合
     * @return 结果
     */
    public int deleteBoleScriptPredictionRecordByIds(Long[] ids);
}
